package com.ecoolex.ying.space.entity;

import com.ecoolex.framework.common.annotation.Description;
import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import org.springframework.lang.NonNull;

public class PickGoodsExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected Integer offset;

    protected Integer rows;

    public PickGoodsExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public PickGoodsExample orderBy(String orderByClause) {
        this.setOrderByClause(orderByClause);
        return this;
    }

    public PickGoodsExample orderBy(String ... orderByClauses) {
        StringBuffer sb = new StringBuffer();
        for (int i = 0; i < orderByClauses.length; i++) {
            sb.append(orderByClauses[i]);
            if (i < orderByClauses.length - 1) {
                sb.append(" , ");
            }
        }
        this.setOrderByClause(sb.toString());
        return this;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria(this);
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
        rows = null;
        offset = null;
    }

    public static Criteria newAndCreateCriteria() {
        PickGoodsExample example = new PickGoodsExample();
        return example.createCriteria();
    }

    public PickGoodsExample when(boolean condition, IExampleWhen then) {
        if (condition) {
            then.example(this);
        }
        return this;
    }

    public PickGoodsExample when(boolean condition, IExampleWhen then, IExampleWhen otherwise) {
        if (condition) {
            then.example(this);
        } else {
            otherwise.example(this);
        }
        return this;
    }

    public void setOffset(Integer offset) {
        this.offset = offset;
    }

    public Integer getOffset() {
        return this.offset;
    }

    public void setRows(Integer rows) {
        this.rows = rows;
    }

    public Integer getRows() {
        return this.rows;
    }

    public PickGoodsExample limit(Integer rows) {
        this.rows = rows;
        return this;
    }

    public PickGoodsExample limit(Integer offset, Integer rows) {
        this.offset = offset;
        this.rows = rows;
        return this;
    }

    public PickGoodsExample page(Integer page, Integer pageSize) {
        this.offset = page * pageSize;
        this.rows = pageSize;
        return this;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andPickGoodsIdIsNull() {
            addCriterion("pickgoods.PickGoodsId is null");
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdIsNotNull() {
            addCriterion("pickgoods.PickGoodsId is not null");
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdEqualTo(Integer value) {
            addCriterion("pickgoods.PickGoodsId =", value, "pickGoodsId");
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.PickGoodsId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdNotEqualTo(Integer value) {
            addCriterion("pickgoods.PickGoodsId <>", value, "pickGoodsId");
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdNotEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.PickGoodsId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdGreaterThan(Integer value) {
            addCriterion("pickgoods.PickGoodsId >", value, "pickGoodsId");
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdGreaterThanColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.PickGoodsId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("pickgoods.PickGoodsId >=", value, "pickGoodsId");
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdGreaterThanOrEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.PickGoodsId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdLessThan(Integer value) {
            addCriterion("pickgoods.PickGoodsId <", value, "pickGoodsId");
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdLessThanColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.PickGoodsId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdLessThanOrEqualTo(Integer value) {
            addCriterion("pickgoods.PickGoodsId <=", value, "pickGoodsId");
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdLessThanOrEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.PickGoodsId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdIn(List<Integer> values) {
            addCriterion("pickgoods.PickGoodsId in", values, "pickGoodsId");
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdNotIn(List<Integer> values) {
            addCriterion("pickgoods.PickGoodsId not in", values, "pickGoodsId");
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdBetween(Integer value1, Integer value2) {
            addCriterion("pickgoods.PickGoodsId between", value1, value2, "pickGoodsId");
            return (Criteria) this;
        }

        public Criteria andPickGoodsIdNotBetween(Integer value1, Integer value2) {
            addCriterion("pickgoods.PickGoodsId not between", value1, value2, "pickGoodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdIsNull() {
            addCriterion("pickgoods.GoodsId is null");
            return (Criteria) this;
        }

        public Criteria andGoodsIdIsNotNull() {
            addCriterion("pickgoods.GoodsId is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsIdEqualTo(Integer value) {
            addCriterion("pickgoods.GoodsId =", value, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.GoodsId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andGoodsIdNotEqualTo(Integer value) {
            addCriterion("pickgoods.GoodsId <>", value, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdNotEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.GoodsId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andGoodsIdGreaterThan(Integer value) {
            addCriterion("pickgoods.GoodsId >", value, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdGreaterThanColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.GoodsId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andGoodsIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("pickgoods.GoodsId >=", value, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdGreaterThanOrEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.GoodsId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andGoodsIdLessThan(Integer value) {
            addCriterion("pickgoods.GoodsId <", value, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdLessThanColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.GoodsId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andGoodsIdLessThanOrEqualTo(Integer value) {
            addCriterion("pickgoods.GoodsId <=", value, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdLessThanOrEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.GoodsId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andGoodsIdIn(List<Integer> values) {
            addCriterion("pickgoods.GoodsId in", values, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdNotIn(List<Integer> values) {
            addCriterion("pickgoods.GoodsId not in", values, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdBetween(Integer value1, Integer value2) {
            addCriterion("pickgoods.GoodsId between", value1, value2, "goodsId");
            return (Criteria) this;
        }

        public Criteria andGoodsIdNotBetween(Integer value1, Integer value2) {
            addCriterion("pickgoods.GoodsId not between", value1, value2, "goodsId");
            return (Criteria) this;
        }

        public Criteria andNameIsNull() {
            addCriterion("pickgoods.`Name` is null");
            return (Criteria) this;
        }

        public Criteria andNameIsNotNull() {
            addCriterion("pickgoods.`Name` is not null");
            return (Criteria) this;
        }

        public Criteria andNameEqualTo(String value) {
            addCriterion("pickgoods.`Name` =", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.`Name` = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNameNotEqualTo(String value) {
            addCriterion("pickgoods.`Name` <>", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.`Name` <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNameGreaterThan(String value) {
            addCriterion("pickgoods.`Name` >", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThanColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.`Name` > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNameGreaterThanOrEqualTo(String value) {
            addCriterion("pickgoods.`Name` >=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThanOrEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.`Name` >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNameLessThan(String value) {
            addCriterion("pickgoods.`Name` <", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThanColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.`Name` < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNameLessThanOrEqualTo(String value) {
            addCriterion("pickgoods.`Name` <=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThanOrEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.`Name` <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andNameLike(String value) {
            addCriterion("pickgoods.`Name` like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotLike(String value) {
            addCriterion("pickgoods.`Name` not like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameIn(List<String> values) {
            addCriterion("pickgoods.`Name` in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotIn(List<String> values) {
            addCriterion("pickgoods.`Name` not in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameBetween(String value1, String value2) {
            addCriterion("pickgoods.`Name` between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotBetween(String value1, String value2) {
            addCriterion("pickgoods.`Name` not between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andClassifyIdIsNull() {
            addCriterion("pickgoods.ClassifyId is null");
            return (Criteria) this;
        }

        public Criteria andClassifyIdIsNotNull() {
            addCriterion("pickgoods.ClassifyId is not null");
            return (Criteria) this;
        }

        public Criteria andClassifyIdEqualTo(Integer value) {
            addCriterion("pickgoods.ClassifyId =", value, "classifyId");
            return (Criteria) this;
        }

        public Criteria andClassifyIdEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.ClassifyId = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andClassifyIdNotEqualTo(Integer value) {
            addCriterion("pickgoods.ClassifyId <>", value, "classifyId");
            return (Criteria) this;
        }

        public Criteria andClassifyIdNotEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.ClassifyId <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andClassifyIdGreaterThan(Integer value) {
            addCriterion("pickgoods.ClassifyId >", value, "classifyId");
            return (Criteria) this;
        }

        public Criteria andClassifyIdGreaterThanColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.ClassifyId > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andClassifyIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("pickgoods.ClassifyId >=", value, "classifyId");
            return (Criteria) this;
        }

        public Criteria andClassifyIdGreaterThanOrEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.ClassifyId >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andClassifyIdLessThan(Integer value) {
            addCriterion("pickgoods.ClassifyId <", value, "classifyId");
            return (Criteria) this;
        }

        public Criteria andClassifyIdLessThanColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.ClassifyId < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andClassifyIdLessThanOrEqualTo(Integer value) {
            addCriterion("pickgoods.ClassifyId <=", value, "classifyId");
            return (Criteria) this;
        }

        public Criteria andClassifyIdLessThanOrEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.ClassifyId <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andClassifyIdIn(List<Integer> values) {
            addCriterion("pickgoods.ClassifyId in", values, "classifyId");
            return (Criteria) this;
        }

        public Criteria andClassifyIdNotIn(List<Integer> values) {
            addCriterion("pickgoods.ClassifyId not in", values, "classifyId");
            return (Criteria) this;
        }

        public Criteria andClassifyIdBetween(Integer value1, Integer value2) {
            addCriterion("pickgoods.ClassifyId between", value1, value2, "classifyId");
            return (Criteria) this;
        }

        public Criteria andClassifyIdNotBetween(Integer value1, Integer value2) {
            addCriterion("pickgoods.ClassifyId not between", value1, value2, "classifyId");
            return (Criteria) this;
        }

        public Criteria andLabelIdsIsNull() {
            addCriterion("pickgoods.LabelIds is null");
            return (Criteria) this;
        }

        public Criteria andLabelIdsIsNotNull() {
            addCriterion("pickgoods.LabelIds is not null");
            return (Criteria) this;
        }

        public Criteria andLabelIdsEqualTo(String value) {
            addCriterion("pickgoods.LabelIds =", value, "labelIds");
            return (Criteria) this;
        }

        public Criteria andLabelIdsEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.LabelIds = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andLabelIdsNotEqualTo(String value) {
            addCriterion("pickgoods.LabelIds <>", value, "labelIds");
            return (Criteria) this;
        }

        public Criteria andLabelIdsNotEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.LabelIds <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andLabelIdsGreaterThan(String value) {
            addCriterion("pickgoods.LabelIds >", value, "labelIds");
            return (Criteria) this;
        }

        public Criteria andLabelIdsGreaterThanColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.LabelIds > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andLabelIdsGreaterThanOrEqualTo(String value) {
            addCriterion("pickgoods.LabelIds >=", value, "labelIds");
            return (Criteria) this;
        }

        public Criteria andLabelIdsGreaterThanOrEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.LabelIds >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andLabelIdsLessThan(String value) {
            addCriterion("pickgoods.LabelIds <", value, "labelIds");
            return (Criteria) this;
        }

        public Criteria andLabelIdsLessThanColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.LabelIds < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andLabelIdsLessThanOrEqualTo(String value) {
            addCriterion("pickgoods.LabelIds <=", value, "labelIds");
            return (Criteria) this;
        }

        public Criteria andLabelIdsLessThanOrEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.LabelIds <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andLabelIdsLike(String value) {
            addCriterion("pickgoods.LabelIds like", value, "labelIds");
            return (Criteria) this;
        }

        public Criteria andLabelIdsNotLike(String value) {
            addCriterion("pickgoods.LabelIds not like", value, "labelIds");
            return (Criteria) this;
        }

        public Criteria andLabelIdsIn(List<String> values) {
            addCriterion("pickgoods.LabelIds in", values, "labelIds");
            return (Criteria) this;
        }

        public Criteria andLabelIdsNotIn(List<String> values) {
            addCriterion("pickgoods.LabelIds not in", values, "labelIds");
            return (Criteria) this;
        }

        public Criteria andLabelIdsBetween(String value1, String value2) {
            addCriterion("pickgoods.LabelIds between", value1, value2, "labelIds");
            return (Criteria) this;
        }

        public Criteria andLabelIdsNotBetween(String value1, String value2) {
            addCriterion("pickgoods.LabelIds not between", value1, value2, "labelIds");
            return (Criteria) this;
        }

        public Criteria andCodedIsNull() {
            addCriterion("pickgoods.Coded is null");
            return (Criteria) this;
        }

        public Criteria andCodedIsNotNull() {
            addCriterion("pickgoods.Coded is not null");
            return (Criteria) this;
        }

        public Criteria andCodedEqualTo(String value) {
            addCriterion("pickgoods.Coded =", value, "coded");
            return (Criteria) this;
        }

        public Criteria andCodedEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.Coded = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCodedNotEqualTo(String value) {
            addCriterion("pickgoods.Coded <>", value, "coded");
            return (Criteria) this;
        }

        public Criteria andCodedNotEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.Coded <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCodedGreaterThan(String value) {
            addCriterion("pickgoods.Coded >", value, "coded");
            return (Criteria) this;
        }

        public Criteria andCodedGreaterThanColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.Coded > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCodedGreaterThanOrEqualTo(String value) {
            addCriterion("pickgoods.Coded >=", value, "coded");
            return (Criteria) this;
        }

        public Criteria andCodedGreaterThanOrEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.Coded >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCodedLessThan(String value) {
            addCriterion("pickgoods.Coded <", value, "coded");
            return (Criteria) this;
        }

        public Criteria andCodedLessThanColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.Coded < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCodedLessThanOrEqualTo(String value) {
            addCriterion("pickgoods.Coded <=", value, "coded");
            return (Criteria) this;
        }

        public Criteria andCodedLessThanOrEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.Coded <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCodedLike(String value) {
            addCriterion("pickgoods.Coded like", value, "coded");
            return (Criteria) this;
        }

        public Criteria andCodedNotLike(String value) {
            addCriterion("pickgoods.Coded not like", value, "coded");
            return (Criteria) this;
        }

        public Criteria andCodedIn(List<String> values) {
            addCriterion("pickgoods.Coded in", values, "coded");
            return (Criteria) this;
        }

        public Criteria andCodedNotIn(List<String> values) {
            addCriterion("pickgoods.Coded not in", values, "coded");
            return (Criteria) this;
        }

        public Criteria andCodedBetween(String value1, String value2) {
            addCriterion("pickgoods.Coded between", value1, value2, "coded");
            return (Criteria) this;
        }

        public Criteria andCodedNotBetween(String value1, String value2) {
            addCriterion("pickgoods.Coded not between", value1, value2, "coded");
            return (Criteria) this;
        }

        public Criteria andCounterPriceIsNull() {
            addCriterion("pickgoods.CounterPrice is null");
            return (Criteria) this;
        }

        public Criteria andCounterPriceIsNotNull() {
            addCriterion("pickgoods.CounterPrice is not null");
            return (Criteria) this;
        }

        public Criteria andCounterPriceEqualTo(BigDecimal value) {
            addCriterion("pickgoods.CounterPrice =", value, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.CounterPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceNotEqualTo(BigDecimal value) {
            addCriterion("pickgoods.CounterPrice <>", value, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceNotEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.CounterPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceGreaterThan(BigDecimal value) {
            addCriterion("pickgoods.CounterPrice >", value, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceGreaterThanColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.CounterPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("pickgoods.CounterPrice >=", value, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceGreaterThanOrEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.CounterPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceLessThan(BigDecimal value) {
            addCriterion("pickgoods.CounterPrice <", value, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceLessThanColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.CounterPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("pickgoods.CounterPrice <=", value, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceLessThanOrEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.CounterPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCounterPriceIn(List<BigDecimal> values) {
            addCriterion("pickgoods.CounterPrice in", values, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceNotIn(List<BigDecimal> values) {
            addCriterion("pickgoods.CounterPrice not in", values, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("pickgoods.CounterPrice between", value1, value2, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andCounterPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("pickgoods.CounterPrice not between", value1, value2, "counterPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceIsNull() {
            addCriterion("pickgoods.RetailPrice is null");
            return (Criteria) this;
        }

        public Criteria andRetailPriceIsNotNull() {
            addCriterion("pickgoods.RetailPrice is not null");
            return (Criteria) this;
        }

        public Criteria andRetailPriceEqualTo(BigDecimal value) {
            addCriterion("pickgoods.RetailPrice =", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.RetailPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceNotEqualTo(BigDecimal value) {
            addCriterion("pickgoods.RetailPrice <>", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceNotEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.RetailPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceGreaterThan(BigDecimal value) {
            addCriterion("pickgoods.RetailPrice >", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceGreaterThanColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.RetailPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("pickgoods.RetailPrice >=", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceGreaterThanOrEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.RetailPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceLessThan(BigDecimal value) {
            addCriterion("pickgoods.RetailPrice <", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceLessThanColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.RetailPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("pickgoods.RetailPrice <=", value, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceLessThanOrEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.RetailPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andRetailPriceIn(List<BigDecimal> values) {
            addCriterion("pickgoods.RetailPrice in", values, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceNotIn(List<BigDecimal> values) {
            addCriterion("pickgoods.RetailPrice not in", values, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("pickgoods.RetailPrice between", value1, value2, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andRetailPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("pickgoods.RetailPrice not between", value1, value2, "retailPrice");
            return (Criteria) this;
        }

        public Criteria andMinProductCounterPriceIsNull() {
            addCriterion("pickgoods.MinProductCounterPrice is null");
            return (Criteria) this;
        }

        public Criteria andMinProductCounterPriceIsNotNull() {
            addCriterion("pickgoods.MinProductCounterPrice is not null");
            return (Criteria) this;
        }

        public Criteria andMinProductCounterPriceEqualTo(BigDecimal value) {
            addCriterion("pickgoods.MinProductCounterPrice =", value, "minProductCounterPrice");
            return (Criteria) this;
        }

        public Criteria andMinProductCounterPriceEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.MinProductCounterPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMinProductCounterPriceNotEqualTo(BigDecimal value) {
            addCriterion("pickgoods.MinProductCounterPrice <>", value, "minProductCounterPrice");
            return (Criteria) this;
        }

        public Criteria andMinProductCounterPriceNotEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.MinProductCounterPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMinProductCounterPriceGreaterThan(BigDecimal value) {
            addCriterion("pickgoods.MinProductCounterPrice >", value, "minProductCounterPrice");
            return (Criteria) this;
        }

        public Criteria andMinProductCounterPriceGreaterThanColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.MinProductCounterPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMinProductCounterPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("pickgoods.MinProductCounterPrice >=", value, "minProductCounterPrice");
            return (Criteria) this;
        }

        public Criteria andMinProductCounterPriceGreaterThanOrEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.MinProductCounterPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMinProductCounterPriceLessThan(BigDecimal value) {
            addCriterion("pickgoods.MinProductCounterPrice <", value, "minProductCounterPrice");
            return (Criteria) this;
        }

        public Criteria andMinProductCounterPriceLessThanColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.MinProductCounterPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMinProductCounterPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("pickgoods.MinProductCounterPrice <=", value, "minProductCounterPrice");
            return (Criteria) this;
        }

        public Criteria andMinProductCounterPriceLessThanOrEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.MinProductCounterPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMinProductCounterPriceIn(List<BigDecimal> values) {
            addCriterion("pickgoods.MinProductCounterPrice in", values, "minProductCounterPrice");
            return (Criteria) this;
        }

        public Criteria andMinProductCounterPriceNotIn(List<BigDecimal> values) {
            addCriterion("pickgoods.MinProductCounterPrice not in", values, "minProductCounterPrice");
            return (Criteria) this;
        }

        public Criteria andMinProductCounterPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("pickgoods.MinProductCounterPrice between", value1, value2, "minProductCounterPrice");
            return (Criteria) this;
        }

        public Criteria andMinProductCounterPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("pickgoods.MinProductCounterPrice not between", value1, value2, "minProductCounterPrice");
            return (Criteria) this;
        }

        public Criteria andMaxProductCounterPriceIsNull() {
            addCriterion("pickgoods.MaxProductCounterPrice is null");
            return (Criteria) this;
        }

        public Criteria andMaxProductCounterPriceIsNotNull() {
            addCriterion("pickgoods.MaxProductCounterPrice is not null");
            return (Criteria) this;
        }

        public Criteria andMaxProductCounterPriceEqualTo(BigDecimal value) {
            addCriterion("pickgoods.MaxProductCounterPrice =", value, "maxProductCounterPrice");
            return (Criteria) this;
        }

        public Criteria andMaxProductCounterPriceEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.MaxProductCounterPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMaxProductCounterPriceNotEqualTo(BigDecimal value) {
            addCriterion("pickgoods.MaxProductCounterPrice <>", value, "maxProductCounterPrice");
            return (Criteria) this;
        }

        public Criteria andMaxProductCounterPriceNotEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.MaxProductCounterPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMaxProductCounterPriceGreaterThan(BigDecimal value) {
            addCriterion("pickgoods.MaxProductCounterPrice >", value, "maxProductCounterPrice");
            return (Criteria) this;
        }

        public Criteria andMaxProductCounterPriceGreaterThanColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.MaxProductCounterPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMaxProductCounterPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("pickgoods.MaxProductCounterPrice >=", value, "maxProductCounterPrice");
            return (Criteria) this;
        }

        public Criteria andMaxProductCounterPriceGreaterThanOrEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.MaxProductCounterPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMaxProductCounterPriceLessThan(BigDecimal value) {
            addCriterion("pickgoods.MaxProductCounterPrice <", value, "maxProductCounterPrice");
            return (Criteria) this;
        }

        public Criteria andMaxProductCounterPriceLessThanColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.MaxProductCounterPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMaxProductCounterPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("pickgoods.MaxProductCounterPrice <=", value, "maxProductCounterPrice");
            return (Criteria) this;
        }

        public Criteria andMaxProductCounterPriceLessThanOrEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.MaxProductCounterPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMaxProductCounterPriceIn(List<BigDecimal> values) {
            addCriterion("pickgoods.MaxProductCounterPrice in", values, "maxProductCounterPrice");
            return (Criteria) this;
        }

        public Criteria andMaxProductCounterPriceNotIn(List<BigDecimal> values) {
            addCriterion("pickgoods.MaxProductCounterPrice not in", values, "maxProductCounterPrice");
            return (Criteria) this;
        }

        public Criteria andMaxProductCounterPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("pickgoods.MaxProductCounterPrice between", value1, value2, "maxProductCounterPrice");
            return (Criteria) this;
        }

        public Criteria andMaxProductCounterPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("pickgoods.MaxProductCounterPrice not between", value1, value2, "maxProductCounterPrice");
            return (Criteria) this;
        }

        public Criteria andMinProductRetailPriceIsNull() {
            addCriterion("pickgoods.MinProductRetailPrice is null");
            return (Criteria) this;
        }

        public Criteria andMinProductRetailPriceIsNotNull() {
            addCriterion("pickgoods.MinProductRetailPrice is not null");
            return (Criteria) this;
        }

        public Criteria andMinProductRetailPriceEqualTo(BigDecimal value) {
            addCriterion("pickgoods.MinProductRetailPrice =", value, "minProductRetailPrice");
            return (Criteria) this;
        }

        public Criteria andMinProductRetailPriceEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.MinProductRetailPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMinProductRetailPriceNotEqualTo(BigDecimal value) {
            addCriterion("pickgoods.MinProductRetailPrice <>", value, "minProductRetailPrice");
            return (Criteria) this;
        }

        public Criteria andMinProductRetailPriceNotEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.MinProductRetailPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMinProductRetailPriceGreaterThan(BigDecimal value) {
            addCriterion("pickgoods.MinProductRetailPrice >", value, "minProductRetailPrice");
            return (Criteria) this;
        }

        public Criteria andMinProductRetailPriceGreaterThanColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.MinProductRetailPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMinProductRetailPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("pickgoods.MinProductRetailPrice >=", value, "minProductRetailPrice");
            return (Criteria) this;
        }

        public Criteria andMinProductRetailPriceGreaterThanOrEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.MinProductRetailPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMinProductRetailPriceLessThan(BigDecimal value) {
            addCriterion("pickgoods.MinProductRetailPrice <", value, "minProductRetailPrice");
            return (Criteria) this;
        }

        public Criteria andMinProductRetailPriceLessThanColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.MinProductRetailPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMinProductRetailPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("pickgoods.MinProductRetailPrice <=", value, "minProductRetailPrice");
            return (Criteria) this;
        }

        public Criteria andMinProductRetailPriceLessThanOrEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.MinProductRetailPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMinProductRetailPriceIn(List<BigDecimal> values) {
            addCriterion("pickgoods.MinProductRetailPrice in", values, "minProductRetailPrice");
            return (Criteria) this;
        }

        public Criteria andMinProductRetailPriceNotIn(List<BigDecimal> values) {
            addCriterion("pickgoods.MinProductRetailPrice not in", values, "minProductRetailPrice");
            return (Criteria) this;
        }

        public Criteria andMinProductRetailPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("pickgoods.MinProductRetailPrice between", value1, value2, "minProductRetailPrice");
            return (Criteria) this;
        }

        public Criteria andMinProductRetailPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("pickgoods.MinProductRetailPrice not between", value1, value2, "minProductRetailPrice");
            return (Criteria) this;
        }

        public Criteria andMaxProductRetailPriceIsNull() {
            addCriterion("pickgoods.MaxProductRetailPrice is null");
            return (Criteria) this;
        }

        public Criteria andMaxProductRetailPriceIsNotNull() {
            addCriterion("pickgoods.MaxProductRetailPrice is not null");
            return (Criteria) this;
        }

        public Criteria andMaxProductRetailPriceEqualTo(BigDecimal value) {
            addCriterion("pickgoods.MaxProductRetailPrice =", value, "maxProductRetailPrice");
            return (Criteria) this;
        }

        public Criteria andMaxProductRetailPriceEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.MaxProductRetailPrice = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMaxProductRetailPriceNotEqualTo(BigDecimal value) {
            addCriterion("pickgoods.MaxProductRetailPrice <>", value, "maxProductRetailPrice");
            return (Criteria) this;
        }

        public Criteria andMaxProductRetailPriceNotEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.MaxProductRetailPrice <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMaxProductRetailPriceGreaterThan(BigDecimal value) {
            addCriterion("pickgoods.MaxProductRetailPrice >", value, "maxProductRetailPrice");
            return (Criteria) this;
        }

        public Criteria andMaxProductRetailPriceGreaterThanColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.MaxProductRetailPrice > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMaxProductRetailPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("pickgoods.MaxProductRetailPrice >=", value, "maxProductRetailPrice");
            return (Criteria) this;
        }

        public Criteria andMaxProductRetailPriceGreaterThanOrEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.MaxProductRetailPrice >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMaxProductRetailPriceLessThan(BigDecimal value) {
            addCriterion("pickgoods.MaxProductRetailPrice <", value, "maxProductRetailPrice");
            return (Criteria) this;
        }

        public Criteria andMaxProductRetailPriceLessThanColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.MaxProductRetailPrice < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMaxProductRetailPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("pickgoods.MaxProductRetailPrice <=", value, "maxProductRetailPrice");
            return (Criteria) this;
        }

        public Criteria andMaxProductRetailPriceLessThanOrEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.MaxProductRetailPrice <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andMaxProductRetailPriceIn(List<BigDecimal> values) {
            addCriterion("pickgoods.MaxProductRetailPrice in", values, "maxProductRetailPrice");
            return (Criteria) this;
        }

        public Criteria andMaxProductRetailPriceNotIn(List<BigDecimal> values) {
            addCriterion("pickgoods.MaxProductRetailPrice not in", values, "maxProductRetailPrice");
            return (Criteria) this;
        }

        public Criteria andMaxProductRetailPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("pickgoods.MaxProductRetailPrice between", value1, value2, "maxProductRetailPrice");
            return (Criteria) this;
        }

        public Criteria andMaxProductRetailPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("pickgoods.MaxProductRetailPrice not between", value1, value2, "maxProductRetailPrice");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeIsNull() {
            addCriterion("pickgoods.CurrencyType is null");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeIsNotNull() {
            addCriterion("pickgoods.CurrencyType is not null");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeEqualTo(String value) {
            addCriterion("pickgoods.CurrencyType =", value, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.CurrencyType = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeNotEqualTo(String value) {
            addCriterion("pickgoods.CurrencyType <>", value, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeNotEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.CurrencyType <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeGreaterThan(String value) {
            addCriterion("pickgoods.CurrencyType >", value, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeGreaterThanColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.CurrencyType > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeGreaterThanOrEqualTo(String value) {
            addCriterion("pickgoods.CurrencyType >=", value, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeGreaterThanOrEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.CurrencyType >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeLessThan(String value) {
            addCriterion("pickgoods.CurrencyType <", value, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeLessThanColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.CurrencyType < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeLessThanOrEqualTo(String value) {
            addCriterion("pickgoods.CurrencyType <=", value, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeLessThanOrEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.CurrencyType <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeLike(String value) {
            addCriterion("pickgoods.CurrencyType like", value, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeNotLike(String value) {
            addCriterion("pickgoods.CurrencyType not like", value, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeIn(List<String> values) {
            addCriterion("pickgoods.CurrencyType in", values, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeNotIn(List<String> values) {
            addCriterion("pickgoods.CurrencyType not in", values, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeBetween(String value1, String value2) {
            addCriterion("pickgoods.CurrencyType between", value1, value2, "currencyType");
            return (Criteria) this;
        }

        public Criteria andCurrencyTypeNotBetween(String value1, String value2) {
            addCriterion("pickgoods.CurrencyType not between", value1, value2, "currencyType");
            return (Criteria) this;
        }

        public Criteria andImageIsNull() {
            addCriterion("pickgoods.Image is null");
            return (Criteria) this;
        }

        public Criteria andImageIsNotNull() {
            addCriterion("pickgoods.Image is not null");
            return (Criteria) this;
        }

        public Criteria andImageEqualTo(String value) {
            addCriterion("pickgoods.Image =", value, "image");
            return (Criteria) this;
        }

        public Criteria andImageEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.Image = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andImageNotEqualTo(String value) {
            addCriterion("pickgoods.Image <>", value, "image");
            return (Criteria) this;
        }

        public Criteria andImageNotEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.Image <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andImageGreaterThan(String value) {
            addCriterion("pickgoods.Image >", value, "image");
            return (Criteria) this;
        }

        public Criteria andImageGreaterThanColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.Image > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andImageGreaterThanOrEqualTo(String value) {
            addCriterion("pickgoods.Image >=", value, "image");
            return (Criteria) this;
        }

        public Criteria andImageGreaterThanOrEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.Image >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andImageLessThan(String value) {
            addCriterion("pickgoods.Image <", value, "image");
            return (Criteria) this;
        }

        public Criteria andImageLessThanColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.Image < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andImageLessThanOrEqualTo(String value) {
            addCriterion("pickgoods.Image <=", value, "image");
            return (Criteria) this;
        }

        public Criteria andImageLessThanOrEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.Image <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andImageLike(String value) {
            addCriterion("pickgoods.Image like", value, "image");
            return (Criteria) this;
        }

        public Criteria andImageNotLike(String value) {
            addCriterion("pickgoods.Image not like", value, "image");
            return (Criteria) this;
        }

        public Criteria andImageIn(List<String> values) {
            addCriterion("pickgoods.Image in", values, "image");
            return (Criteria) this;
        }

        public Criteria andImageNotIn(List<String> values) {
            addCriterion("pickgoods.Image not in", values, "image");
            return (Criteria) this;
        }

        public Criteria andImageBetween(String value1, String value2) {
            addCriterion("pickgoods.Image between", value1, value2, "image");
            return (Criteria) this;
        }

        public Criteria andImageNotBetween(String value1, String value2) {
            addCriterion("pickgoods.Image not between", value1, value2, "image");
            return (Criteria) this;
        }

        public Criteria andShopwindowImagesIsNull() {
            addCriterion("pickgoods.ShopwindowImages is null");
            return (Criteria) this;
        }

        public Criteria andShopwindowImagesIsNotNull() {
            addCriterion("pickgoods.ShopwindowImages is not null");
            return (Criteria) this;
        }

        public Criteria andShopwindowImagesEqualTo(String value) {
            addCriterion("pickgoods.ShopwindowImages =", value, "shopwindowImages");
            return (Criteria) this;
        }

        public Criteria andShopwindowImagesEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.ShopwindowImages = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andShopwindowImagesNotEqualTo(String value) {
            addCriterion("pickgoods.ShopwindowImages <>", value, "shopwindowImages");
            return (Criteria) this;
        }

        public Criteria andShopwindowImagesNotEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.ShopwindowImages <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andShopwindowImagesGreaterThan(String value) {
            addCriterion("pickgoods.ShopwindowImages >", value, "shopwindowImages");
            return (Criteria) this;
        }

        public Criteria andShopwindowImagesGreaterThanColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.ShopwindowImages > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andShopwindowImagesGreaterThanOrEqualTo(String value) {
            addCriterion("pickgoods.ShopwindowImages >=", value, "shopwindowImages");
            return (Criteria) this;
        }

        public Criteria andShopwindowImagesGreaterThanOrEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.ShopwindowImages >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andShopwindowImagesLessThan(String value) {
            addCriterion("pickgoods.ShopwindowImages <", value, "shopwindowImages");
            return (Criteria) this;
        }

        public Criteria andShopwindowImagesLessThanColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.ShopwindowImages < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andShopwindowImagesLessThanOrEqualTo(String value) {
            addCriterion("pickgoods.ShopwindowImages <=", value, "shopwindowImages");
            return (Criteria) this;
        }

        public Criteria andShopwindowImagesLessThanOrEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.ShopwindowImages <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andShopwindowImagesLike(String value) {
            addCriterion("pickgoods.ShopwindowImages like", value, "shopwindowImages");
            return (Criteria) this;
        }

        public Criteria andShopwindowImagesNotLike(String value) {
            addCriterion("pickgoods.ShopwindowImages not like", value, "shopwindowImages");
            return (Criteria) this;
        }

        public Criteria andShopwindowImagesIn(List<String> values) {
            addCriterion("pickgoods.ShopwindowImages in", values, "shopwindowImages");
            return (Criteria) this;
        }

        public Criteria andShopwindowImagesNotIn(List<String> values) {
            addCriterion("pickgoods.ShopwindowImages not in", values, "shopwindowImages");
            return (Criteria) this;
        }

        public Criteria andShopwindowImagesBetween(String value1, String value2) {
            addCriterion("pickgoods.ShopwindowImages between", value1, value2, "shopwindowImages");
            return (Criteria) this;
        }

        public Criteria andShopwindowImagesNotBetween(String value1, String value2) {
            addCriterion("pickgoods.ShopwindowImages not between", value1, value2, "shopwindowImages");
            return (Criteria) this;
        }

        public Criteria andSourceIsNull() {
            addCriterion("pickgoods.`Source` is null");
            return (Criteria) this;
        }

        public Criteria andSourceIsNotNull() {
            addCriterion("pickgoods.`Source` is not null");
            return (Criteria) this;
        }

        public Criteria andSourceEqualTo(Integer value) {
            addCriterion("pickgoods.`Source` =", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.`Source` = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSourceNotEqualTo(Integer value) {
            addCriterion("pickgoods.`Source` <>", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.`Source` <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSourceGreaterThan(Integer value) {
            addCriterion("pickgoods.`Source` >", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceGreaterThanColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.`Source` > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSourceGreaterThanOrEqualTo(Integer value) {
            addCriterion("pickgoods.`Source` >=", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceGreaterThanOrEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.`Source` >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSourceLessThan(Integer value) {
            addCriterion("pickgoods.`Source` <", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceLessThanColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.`Source` < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSourceLessThanOrEqualTo(Integer value) {
            addCriterion("pickgoods.`Source` <=", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceLessThanOrEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.`Source` <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andSourceIn(List<Integer> values) {
            addCriterion("pickgoods.`Source` in", values, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotIn(List<Integer> values) {
            addCriterion("pickgoods.`Source` not in", values, "source");
            return (Criteria) this;
        }

        public Criteria andSourceBetween(Integer value1, Integer value2) {
            addCriterion("pickgoods.`Source` between", value1, value2, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotBetween(Integer value1, Integer value2) {
            addCriterion("pickgoods.`Source` not between", value1, value2, "source");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("pickgoods.`Status` is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("pickgoods.`Status` is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("pickgoods.`Status` =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.`Status` = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Integer value) {
            addCriterion("pickgoods.`Status` <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.`Status` <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Integer value) {
            addCriterion("pickgoods.`Status` >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.`Status` > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("pickgoods.`Status` >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.`Status` >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Integer value) {
            addCriterion("pickgoods.`Status` <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.`Status` < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Integer value) {
            addCriterion("pickgoods.`Status` <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.`Status` <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Integer> values) {
            addCriterion("pickgoods.`Status` in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Integer> values) {
            addCriterion("pickgoods.`Status` not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Integer value1, Integer value2) {
            addCriterion("pickgoods.`Status` between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("pickgoods.`Status` not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNull() {
            addCriterion("pickgoods.Deleted is null");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNotNull() {
            addCriterion("pickgoods.Deleted is not null");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualTo(Boolean value) {
            addCriterion("pickgoods.Deleted =", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.Deleted = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualTo(Boolean value) {
            addCriterion("pickgoods.Deleted <>", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.Deleted <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThan(Boolean value) {
            addCriterion("pickgoods.Deleted >", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.Deleted > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualTo(Boolean value) {
            addCriterion("pickgoods.Deleted >=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.Deleted >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedLessThan(Boolean value) {
            addCriterion("pickgoods.Deleted <", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.Deleted < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualTo(Boolean value) {
            addCriterion("pickgoods.Deleted <=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.Deleted <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andDeletedIn(List<Boolean> values) {
            addCriterion("pickgoods.Deleted in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotIn(List<Boolean> values) {
            addCriterion("pickgoods.Deleted not in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedBetween(Boolean value1, Boolean value2) {
            addCriterion("pickgoods.Deleted between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotBetween(Boolean value1, Boolean value2) {
            addCriterion("pickgoods.Deleted not between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNull() {
            addCriterion("pickgoods.`CreateUser` is null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNotNull() {
            addCriterion("pickgoods.`CreateUser` is not null");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualTo(String value) {
            addCriterion("pickgoods.`CreateUser` =", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.`CreateUser` = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualTo(String value) {
            addCriterion("pickgoods.`CreateUser` <>", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.`CreateUser` <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThan(String value) {
            addCriterion("pickgoods.`CreateUser` >", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.`CreateUser` > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualTo(String value) {
            addCriterion("pickgoods.`CreateUser` >=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.`CreateUser` >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThan(String value) {
            addCriterion("pickgoods.`CreateUser` <", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.`CreateUser` < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualTo(String value) {
            addCriterion("pickgoods.`CreateUser` <=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.`CreateUser` <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateUserLike(String value) {
            addCriterion("pickgoods.`CreateUser` like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotLike(String value) {
            addCriterion("pickgoods.`CreateUser` not like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserIn(List<String> values) {
            addCriterion("pickgoods.`CreateUser` in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotIn(List<String> values) {
            addCriterion("pickgoods.`CreateUser` not in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserBetween(String value1, String value2) {
            addCriterion("pickgoods.`CreateUser` between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotBetween(String value1, String value2) {
            addCriterion("pickgoods.`CreateUser` not between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("pickgoods.CreateTime is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("pickgoods.CreateTime is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("pickgoods.CreateTime =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.CreateTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("pickgoods.CreateTime <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.CreateTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("pickgoods.CreateTime >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.CreateTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("pickgoods.CreateTime >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.CreateTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("pickgoods.CreateTime <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.CreateTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("pickgoods.CreateTime <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.CreateTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("pickgoods.CreateTime in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("pickgoods.CreateTime not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("pickgoods.CreateTime between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("pickgoods.CreateTime not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNull() {
            addCriterion("pickgoods.UpdateUser is null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNotNull() {
            addCriterion("pickgoods.UpdateUser is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualTo(String value) {
            addCriterion("pickgoods.UpdateUser =", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.UpdateUser = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualTo(String value) {
            addCriterion("pickgoods.UpdateUser <>", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.UpdateUser <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThan(String value) {
            addCriterion("pickgoods.UpdateUser >", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.UpdateUser > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualTo(String value) {
            addCriterion("pickgoods.UpdateUser >=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.UpdateUser >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThan(String value) {
            addCriterion("pickgoods.UpdateUser <", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.UpdateUser < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualTo(String value) {
            addCriterion("pickgoods.UpdateUser <=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.UpdateUser <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateUserLike(String value) {
            addCriterion("pickgoods.UpdateUser like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotLike(String value) {
            addCriterion("pickgoods.UpdateUser not like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIn(List<String> values) {
            addCriterion("pickgoods.UpdateUser in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotIn(List<String> values) {
            addCriterion("pickgoods.UpdateUser not in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserBetween(String value1, String value2) {
            addCriterion("pickgoods.UpdateUser between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotBetween(String value1, String value2) {
            addCriterion("pickgoods.UpdateUser not between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("pickgoods.UpdateTime is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("pickgoods.UpdateTime is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("pickgoods.UpdateTime =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.UpdateTime = ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("pickgoods.UpdateTime <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.UpdateTime <> ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("pickgoods.UpdateTime >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.UpdateTime > ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("pickgoods.UpdateTime >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.UpdateTime >= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("pickgoods.UpdateTime <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.UpdateTime < ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("pickgoods.UpdateTime <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualToColumn(PickGoodsWithBLOBs.Column column) {
            addCriterion(new StringBuilder("pickgoods.UpdateTime <= ").append(column.getEscapedColumnName()).toString());
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("pickgoods.UpdateTime in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("pickgoods.UpdateTime not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("pickgoods.UpdateTime between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("pickgoods.UpdateTime not between", value1, value2, "updateTime");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {
        private PickGoodsExample example;

        protected Criteria(PickGoodsExample example) {
            super();
            this.example = example;
        }

        public PickGoodsExample example() {
            return this.example;
        }

        @Deprecated
        public Criteria andIf(boolean ifAdd, ICriteriaAdd add) {
            if (ifAdd) {
                add.add(this);
            }
            return this;
        }

        public Criteria when(boolean condition, ICriteriaWhen then) {
            if (condition) {
                then.criteria(this);
            }
            return this;
        }

        public Criteria when(boolean condition, ICriteriaWhen then, ICriteriaWhen otherwise) {
            if (condition) {
                then.criteria(this);
            } else {
                otherwise.criteria(this);
            }
            return this;
        }

        public Criteria andLogicalDeleted(boolean deleted) {
            return deleted ? andDeletedEqualTo(PickGoods.Deleted.IS_DELETED.value()) : andDeletedNotEqualTo(PickGoods.Deleted.IS_DELETED.value());
        }

        @Deprecated
        public interface ICriteriaAdd {
            Criteria add(Criteria add);
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }

    public interface ICriteriaWhen {
        void criteria(Criteria criteria);
    }

    public interface IExampleWhen {
        void example(com.ecoolex.ying.space.entity.PickGoodsExample example);
    }
}